Error: Some list items ignored due to list contains mixture of text & numbers.
Error:
Cells without simple text were ignored.
Cause:
The custom list being imported from a range of cells on a worksheet contains a mixture of text and numbers. If the custom list contains only text data or only numeric data, the list imports without the error message. Microsoft has confirmed this to be a problem with Excel at this point.
Solution:
To work around this problem, enter the worksheet data to be used in the custom list as text. To enter a number as text, type an apostrophe (') before the number.
